class CreateObservedValues < ActiveRecord::Migration
  def self.up
    create_table :observed_values do |t|
      t.column :real_survey_point_id, :int,    :null => false
      t.column :current_value,        :float
      t.column :created_at,           :date
      t.column :created_hour,         :string, :limit => 2
      t.column :instrument_id,        :int,    :null => false
      t.column :person_id,            :int,    :null => false
    end
  end

  def self.down
    drop_table :observed_values
  end
end
